GoldenGate Bridges the gaps between Production and BCP
Oracle GoldenGate is used as part of our business continuity plan. We use it to replicate in near realtime, transactions from the primary …
Starting at $250 Per License
View PricingOverview
What is Oracle GoldenGate?
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
Data Integration
$250.00
Cloud
Per License
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://cloud.oracle.com/en_US/goldenga…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
Oracle Goldengate demo
YouTube
Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_31st May
YouTube
2017 05 19 22 04 Oracle Goldengate Demo
YouTube
Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_14 June
YouTube
Oracle 12c Golgen Gate Essentials Training - DEMO
YouTube
Configuring Integrated Extract and Integrated Replicat Using Oracle GoldenGate 12c on Linux
YouTube
Product Details
- About
- Integrations
- Competitors
- Tech Details
- Downloadables
- FAQs
What is Oracle GoldenGate?
Oracle GoldenGate products offer real-time data integration, transactional data replication, and data comparison across heterogeneous systems. Oracle GoldenGate enables:
-Real-time business intelligence and stream analytics for improved business insight
-Query offloading to maximize OLTP performance
-Zero-downtime data migration, disaster recovery, and active-active database synchronization for continuous availability
Datasheet - https://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-2030490.pdf
Datasheet (Stream Analytics) https://www.oracle.com/us/products/middleware/data-integration/oracle-stream-analytics-ds-4478221.pd...
Analyst whitepaper https://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-2030490.pdf
Documentation
Video Oracle GoldenGate Cloud Service - Get an overview of this cloud based real-time data integration and replication service that provides quick, easy, accurate and safe data movement to the cloud. https://youtu.be/liBgUwHgVew
Oracle GoldenGate Video
GoldenGate Cloud for real-time replication
Oracle GoldenGate Integrations
Oracle GoldenGate Competitors
Oracle GoldenGate Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
Oracle GoldenGate Downloadables
Frequently Asked Questions
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
Azure Data Factory, AWS Database Migration Service, and Informatica Cloud Data Integration are common alternatives for Oracle GoldenGate.
Reviewers rate Oracle Implementation Satisfaction highest, with a score of 9.7.
The most common users of Oracle GoldenGate are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(221)Attribute Ratings
Reviews
(1-8 of 8)Companies can't remove reviews or game the system. Here's why
December 13, 2020
GoldenGate - Ideal Synchronization for Low/Moderate Data Complexity
<p>GoldenGate (GG) is being used by the utility company I work
for in various areas. </p>
<p>Data Analytics is the main use of GG at the moment. Normally, the sheer level of database hits
required by our daily Business Intelligence reports would place a heavy burden on
the disk groups in our core ASM; however, with GG, we are able to seamlessly
replicate that data in real-time into a separate database using separate
resources. By doing this, we are able to
alleviate potential bandwidth issues posed by our BI group’s database querying. It should be noted that GG does not require
all tables to be replicated: we only replicate under 100 of the thousands of
tables in the main databases. Our GG
database is not normalized, so we are essentially combining disparate databases
into one, which has its advantages and disadvantages.</p>
<p>Another use we currently have for GoldenGate is on a
large project level. As part of a data
conversion effort, we are using GoldenGate to replicate data into a separate
database in real-time. This will allow
us to save 12+ hours during our conversion, as well will not need to execute an
RMAN backup in order to move data into our target database. In other words, we are directly replicating
data into our target database, so right when we are ready to switch
servers/databases for the go-live of our project, we will be ready to
immediately start to convert data.</p>
- Replicates data without "missing" items. This is key, as there was initial concern that with the amount of tables and columns involved, certain items were bound to be "missed", though we have not seen this (outside of an anomalous server crash incident that wasn't due to GG).
- Replicates data in real-time. Proof of concept for GG was intuitive for end users, as the data is immediately available. There are no "jobs" or "interfaces" that need to be run: the data is immediately available on the target database for viewing
- GG is able to modify data "in transit", which can save loads of time if you were to need to instead modify large amounts of data after it is synchronized to the target database. As one would expect, this is seamless with low complexity modification, by can become untenable with larger blocks of data (e.g. CLOBs).
- GG can sometimes lag behind in synching large objects (i.e. CLOBs and BLOBs) on tables, which is odd because we are using GG on an Oracle database with an Oracle software suite. It's definitely possible to use GG on non-LOB columns, and we do, but it is best used for non-LOB columns, just based on personal experience.
- When using GG, it is key to separate the replicat groups into manageable sizes. This can be somewhat burdensome, as maintenance will increase with each new replicat group. If tables are large enough, they need to essentially be their own group.
- Sometimes, replicat groups need to be grouped by parent and child (if using in a normalized db). This again increases maintenance due to more groups existing. This will be especially true for large tables that are partitioned with foreign key constraints on child tables.
October 07, 2019
The Golden Gate to Success!
Oracle GoldenGate is being used by our core software development team. We are using it as a real-time data replication solution to achieve high availability/disaster recovery for our data, to prepare a read-replica database to offload query-based requests, and to perform real-time business intelligence related operations on our synced data.
- No Downtime during System Migration. Replicating data onto other servers in preparation for a system migration does not result in any downtime.
- Initial setup of Oracle GoldenGate is easy and straightforward. Instructions are precise and simple to follow.
- Thorough and Insightful Documentation. All troubleshooting and tuning issues are well-known by the community, and hence are well-documented online.
- Lack of Simple UI for Non-Technical Users. It would be nice to have an option to toggle simpler, and less advanced options to make it easier for non-technical users to understand what Oracle GoldenGate is.
- Lack of Variety of Performance Metrics. Would prefer more detailed performance metrics to be offered out-of-the-box.
- Some Features Won't Always Run as Expected. We have sometimes faced issues when features don't run as they are used to. They will be working at times, but there is the occasional failure in streaming.
September 16, 2019
Synchronize your data with ease
We are using OGG to synchronize our UAT/Production database with Oracle Cloud. The set up is being done by administrators and used only by the channels manager and administrator. One of the problems we found is the product cost, specifically after moving from Oracle Classic to OCI. In addition, we didn't find clear documentation to describe what we exactly can do with sequences synchronization. The user interface is another product and we have to purchase it to be able to monitor GG performance and issues.
- Initiating integration and configuring source and target is easy.
- Easy integration with different types of DB.
- Availability to synchronize specific tables/DB schemas.
- No clear documentation for some points like sequence synchronization.
September 16, 2019
Sr. Database Engineer
We have multiple data centers and all of them share the same copy of DB. We use GoldenGate to do cross datacenters replication for Oracle and My SQL DBs as an HA solution. As our DBs are one of the busiest in the world and have a very tight SLA for replication lag which we can achieve by GoldenGate. We have explored few other products like SharePlex but GG done the work for us. GoldenGate is a de-facto standard for replication in our organization.
- GoldenGate is tightly integrated with Oracle databases and supports all features like encryption, LOBs, compressions etc.
- GoldenGate is very flexible, you can customize it as per your requirement. Whether it is high transaction DB or a DR site, it can work anywhere.
- We can dump data in multiple formats with big data adaptor like kafka, hdfs, xml etc.
- We can achieve high throughput by splitting extracts and replicats. Also from integrated capture and replication it is so smart that it spawn parallel process based on the load.
- Goldengate is very useful in cross platform migration.
- Memory consumption of extract is exponentially high, sometimes extract restart consumes so much memory that it impact the current application connections.
- There are so many bugs in the system for dumping data via xml or other format like hdfs. Data corruption is so frequent that we wrote our own scripts to detect and repair xml corruption. As always we didn't get proper support from Oracle on this issue.
- For active-active replication on busy systems, online DDL change can sometimes cause data discrepancy.
- With integrated capture creating index on big table is a headache even thought you are creating with via gg user. Extract starts get lagging even after skipping the DDL by gg user in param file. This was not the case with classic capture.
November 09, 2018
GoldenGate with 99.999 uptime
We use Oracle GoldenGate to achieve high availability, perform upgrades, and for patching and data center drills.
We use Golden Gate in active active configuration.
It meets our SLA requirement of 99999.
- Oracle GoldenGate provides the best HA solution. It gives us 99.999% availability in a year.
- GoldenGate is very easy to install, set up and troubleshoot. The commands are fairly simple.
- GoldenGate is a very lightweight tool. It performs auto CDR in active setups.
- Tuning Golden Gate is fairly very simple.
- Golden Gate is very fast in catching up the lag.
- Where there are open transactions GoldenGate needs to auto-detect them.
- GoldenGate should have dba views like Oracle Database.
- Patching or upgrading GoldenGate is a bit complicated.
- When extract or pump trail file sequence number is about to reach the max limit, we should get a warning or critical threshold alert.
- When Integrated replicat is altered, it converts to classic replicat. We don't get any message that the replicat is running in classic mode. There should be some sort of alerting in the ggserrlog file.
November 07, 2018
MyCentsonGold
We are using this application to replicate data from one data center to other data center. And it's very accurate and it's solved our data issues during the down time the replication helped not loosing of business and with little impact to customer for check out and creating profiles
- Well organized and greater data integration
- Response Time(no latency) able to sustain the load during the process
- Because of Golden Gate our business able to deliver the continuance and high availability of the application
- Less hassles of maintenance
- Little more flexibility and should be more robustness
- Need improvement on session management
- Replication takes more time - you need a better approach with less time
October 30, 2017
Different Source Systems (IBM DB2, Microsoft SQL Server) Are Supported For Real Time Replication.
Replicated source system data seamlessly flew in our Operational Data Store (ODS). Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication. With the upgrade, I now am able to replicate Big Data solution from any supported source system to Hadoop clusters.
- Ease of installation
- Ease of maintenance
- Powerful output with sub-second speed
- Supporting Big Data and Cloud environment
- Capturing source data based on transnational log, no cost on source CPU
- Handle the distribution and the delivery of committed data in real-time
- Supports heterogeneous systems regarding target or source database
- Can be implemented uni-directional, bi-directional or peer-to-peer mode
- Zero downtime migration
- Supports data distribution
- Can be used for disaster recovery or data protection
- Oracle GoldenGate Studio could be more user-friendly.
- It would be better for Oracle Golden Gate Studio GUI to include other OGG related licensed products (i.e. Veridata or others).
November 23, 2016
Real time replication in a Heterogeneous environment
We're in a data warehousing project where we need to replicate from multiple source/intermediary systems (MS SQL Servers and Sybase) into Oracle as our reporting platform. GoldenGate fulfilled our needs of having a reliable means of extracting live data from multiple heterogeneous databases and feed into an EDW. In that sense, it's an invaluable tool for the report writers and business analysts across the organization. There are some hiccups here and there, mostly having to do with some data transformations and certain long transactions, but overall, it performs reliably well and better than other alternative replication products we're tried.
- GoldenGate can handle multiple database vendors (SQL Server, Sybase, DB2, Enscribe, etc.) and replicate data in real-time.
- It's flexible and can perform data transformation/cleansing on the fly when you provide the mapping file for it. Exceptionally good error handling and data collision handling. Over some years, we have some large tables with 10 million records or more, and have seen only a very few records missing/incorrect.
- Good support responses. GoldenGate was well-supported when it was an independent company, and even though Oracle acquired it, it still has a good support organization.
- It's expensive. And I believe you have to purchase a license for each type of source and/or target DB that you're trying to replicate.
- It will be slow for a single transaction that updates a large number of rows. It's better to break up such transactions into batches and run them in a loop with periodic commits (Batch Insert or Batch Update).
- It's buggy when reading SQL Server transaction logs; may cause an abend.